The Market Analysis

The Market Analysis for Communication Services Sector

In this article, the Communication Services Sector from Yahoo! Finance is used, and we analyze the current top tech companies' stock prices.

Table of contentens

Symbol Name Symbol Name Symbol Name
GOOG Alphabet Inc. CHTR Charter Communications, Inc. BIDU Baidu, Inc.
GOOGL Alphabet Inc. TMUS T-Mobile US, Inc. NTES NetEase, Inc.
FB Facebook, Inc. VOD Vodafone Group Plc TEF Telefonica, S.A.
T AT&T Inc. AMX America Movil, S.A.B. de C.V. CHA China Telecom Corporation Limited
DIS The Walt Disney Company AMOV America Movil, S.A.B. de C.V. SIRI Sirius XM Holdings Inc.
VZ Verizon Communications Inc. RELX RELX PLC EA Electronic Arts Inc.
CMCSA Comcast Corporation BCE BCE Inc. CHT Chunghwa Telecom Co., Ltd.
CHL China Mobile Limited ORAN Orange S.A.
NFLX Netflix, Inc. ATVI Activision Blizzard, Inc.

The data is collected from a years ago until now.

Collecting data from Yahoo Finance!, and creating moving Averages for 10, 20 and 60 day periods of time.

Displaying today's data only:

Consider AT&T Inc. for example. We hAve,

Stock Prices Fluctuations

The following table shows the Average values for all columns of the Data.

The Moving Average of the Stocks

The Daily Return Average of a Stock

Daily return can be calculated using the percentage change of the adjusted closing price.

The Correlation Between Daily Returns of Different Stocks

First, we need to create a new data frame by reading the Adj Close column from all stock data under study. We hAve,

The returns can be analyzed using the percentage change from the adj Close.

The following graphs show the correlation between different stocks.

Now, we can use the pairplot tool to visualize all.

Nonetheless, the correlation matrix and plot are always convenient to see numerical values for correlations.

Here, darker shades of blue represent a higher correlation.

We can find the quantile GOOG.

Predicting Future Behaviors

To predict future behaviors, we can implement the Monte Carlo method (also see this [2] and this [3].

Defining a Monte Carlo function fo the Stock price.

Facebook, Inc.

The frequencies of different outcomes simulated form a Bell curve. The most likely return is in the middle of the curve. This means there is an equal chance that the actual return will be higher or lower than that value.

See more details about Value at Risk (VaR) [4].


References

  1. Yahoo Finance
  2. Mathematical Foundations of Monte Carlo Methods
  3. Monte Carlo Simulation
  4. An Introduction to Value at Risk (VAR)
  5. Bell Curve